Rman backup method-Incremental backup and rman backup method incremental
Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is
Oracle rman backup and RestorationRMAN supports Incremental Backup: databases, tablespaces, and data files.Only used blocks can be backed up as backup setIng between tablespaces and data files: dba_data_files/v $ datafile_headerIn noarchivelog mode, you can use
optional and can be backed up regularly separatelyRelease channel c1;}
Ii. Incremental Backup1. Level 0 Incremental BackupCopy codeThe Code is as follows:Run {Allocate channel c1 type disk;Backup incremental level 0 tag 'db0' format'/backup/db0 % u _ % s _ % P' databaseIncl
http://blog.csdn.net/u011364306/article/details/50036429 of Rman Level012 Backup experiment
With a 0221222 incremental backup strategy, 7 days a cycle
That is, Sunday level 0 backup, Week 1 2 4 5 6 using 2 level incremental
---------- Full backup -----------Backup set: block backup used in data filesImage copy: a complete copy of all data files.---------- Incremental Backup -----------A backup of a database that has changed since a specific time poin
steps:
For basic RMAN operations, refer to the http://blog.csdn.net/kkdelta/article/details/7202958
1. grade 0 backup on Sunday
RMAN> run {2> allocate channel C1 type disk;3> Backup incremental level 0 database format 'd: \ oracle \ rmanrep \ butdblv0 % u. dmp ';4>}
2. Data
Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night.
It corresponds to full-Database Backup:
Http://blog.csdn.net/jacson_bai/article/details/39636915
1. env:IP Address: 10.244.171.180/181Oracle Database Oracle 11.2.0.3OS RHEL 5.5Backup toos: rman, Shell, crontab
2.
Tags: redo content orm Pre base class make Device tabStep 1:create the Incremental Backuprman> BACKUP DEVICE TYPE DISK INCREMENTAL from SCN 750983 DATABASE
FORMAT '/tmp/incr_for_standby/bkup_%u ';Step 2:make the Incremental Backup Accessible at the Standby DatabaseFTP o
.2cto.com.For basic RMAN operations, see www.2cto.com/database/201201/117276.html1. grade 0 backup on SundayRMAN> run {2> allocate channel c1 type disk;3> backup incremental level 0 database format 'd: \ oracle \ rmanrep \ butdblv0 % U. dmp ';4>}2. Data changes in the database from Sunday to Monday: insert into test va
Nine Incremental backups
With incremental backups, RMAN allows users to back up only blocks of data that have been modified since the last incremental backup. Incremental backups have the following somewhat:
(1) Less use of disk
.
Each zero-level backup creates a new backup cycle.
For example, in the following backup policy, there is a zero-level Incremental Backup every Sunday evening, a one-level cumulative backup on Wednesday evening, and a level-1 dif
Step 1:create the Incremental Backuprman> BACKUP DEVICE TYPE DISK INCREMENTAL from SCN 750983 DATABASE FORMAT '/tmp/incr_for_standby/bkup_%u ';Step 2:make the Incremental Backup Accessible at the Standby DatabaseFTP or SCP copy incre
Use RMAN Incremental backup to update the transmitted tablespace
To use RMAN Incremental backup to update the transmitted tablespace, you need to understand the Incremental
Label:With 0112111 incremental backup strategy, 7 days a cycle that is, Sunday level 0 backup, Week 1 2 4 5 6 with 2-level incremental backup, week 3 with 1-level incremental backupConfigure control file
. If recovery is required on Saturday, only 1 + 4 + 5 + 6 is required. automatic Backup: backup script + crontab bakl0 bakl1 bakl2
Ii. executed script:
1. Execute the script:
Rman target/msglog = bakl0.log prepare file = bakl0 (/indicates the target database to be connected, msglog indicates the log file, and audit file indicates the script file)
data blocks to know which data blocks have changed (block tracking), which greatly improves backup efficiency. But these are at the expense of disk I/O, so in an OLTP transaction system, you have to measure whether you are willing to use I/O to ensure security and high availability. The 10g also supports incremental consolidation, and incremental backups can sup
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.